<h1 class="top">Select</h1>
<h2>The block</h2>
<img src="help/img/select.png" alt="and Block" class="leftFloatIMG">
<p class="leftFloat left">
    The select block is the block you need to choose, if you want to do a query on you database. It symbolises the query structure.
    All the other blocks, like tables, functions and operators are plugged in it.<br> It also can be mutated.<br>
    If you want to learn more about how to mutate the block please, see <a href="#func" class="groupLinks"> 'Functionality'</a>.<br>
    The not mutated select block is divided in two sections. The 'SELECT'-section and the 'WHERE'-section. 
    This block also changes the colour, to symbolise <a href="#type" class="groupLinks">the types</a> used in SQL.
</p>
<h2 id="func" style="margin-top: 15px;">Functionality</h2>
<h3>'SELECT'-section</h3>
<img src="help/img/select_selectsection.png" alt="How to mutate the select Block" class="img" > 
<p class="text"> Into the 'SELECT'-section you plug all the 
    <span class="groupLinks pointer" onclick="fetchthelink('Help/tables_and_colums.html', '#63a65a');">table and column blocks </span>, 
    which you want to query. You can also blug in the 
    <span class="groupLinks pointer" onclick="fetchthelink('Help/sub_select.html', '#63a65a');">'SUBSELECT' Block</span>  and the 
    <span class="groupLinks pointer" onclick="fetchthelink('Help/groupfunction/avg.html', '#63a65a');">groupfunction</span>.<br> A simple example is shown above.  </p>
<h3>'WHERE'-section</h3>
<img src="help/img/select_wheresection.png" alt="How to mutate the select Block" class="img" > 
<p class="text"> Into the 'WHERE'-section you plug the blocks which require the query. Into the 'WHERE' input you can plug the  
    <span class="groupLinks pointer" onclick="fetchthelink('Help/AND_BOOL.html', '#63a65a');">'AND'-block </span> and the 
    <span class="groupLinks pointer" onclick="fetchthelink('Help/compare_operator.html', '#5aa68c');"> compare operator</span>.
    Every other block to require the search will be plugged into one of the blocks.<br> An example is shown above. </p>
<h3> Mutation</h3>
<p class="text"> To mutate the block, you click on the 
    <span style="color: #A00;">star-icon</span> and a new workspace appears.<br/></p>
<img src="help/img/select_muated.png" alt="How to mutate the select Block" class="img" >
<p class="text">In this workspace you can drop blocks into an 'ADD'-block to expand the select-block. 
    So for each droped block one new input appears. Like you see in the picture above.<br/>
    If you want to reduce the number of inputs, you click on the star icon and pull the blocks out of the 'ADD' block.<br/>
    The blocks in this workspace are the SQL clauses <a href="#gb" class="groupLinks">'GROUP BY'</a>,
    <a href="#gbh" class="groupLinks">GROUP BY' with 'HAVING</a>, 
    <a href="#ob" class="groupLinks">'ORDER BY'</a> and <a href="#lim" class="groupLinks">'LIMIT'</a>. 
    In the section <a href="#clauses" class="groupLinks"> 'Clauses'</a> you will learn more about them. </p> 
<h2 id="func" style="margin-top: 15px;">Clauses</h2> 
<p class="text"> In the mutator workspace are four blocks, symbolizing the clauses, 
    'GROUP BY',GROUP BY' with 'HAVING, 'ORDER BY' and 'LIMIT', in SQL.
    <span style="font-weight: bold;">Notice</span> that the first three clauses could be used with 'LIMIT' but <span style="font-weight: bold;"> not</span> with each other. 
    'LIMIT' could be also  used alone.
</p>
<h3 id="gb"> GROUP BY </h3>
<img src="help/img/select_group.png" alt="Group by" class="rightFloatIMG" style='margin-top:10px'>
<p class="text"> The 'GROUP BY' input is used if you use a <span class="groupLinks pointer" onclick="fetchthelink('Help/groupfunction/avg.html', '#63a65a');">groupfunction</span>. 
    If you use 'GROUP BY' be sure to use the same tables in the group, which you used in the select.<br>
    <span style="font-weight: bold;">Notice</span> that only the tables should be used, which are not in a groupfunction.<br> You can use this clause with the 'LIMIT' clause</p>
<h3 id="gbh"> GROUP BY with HAVING</h3>
<img src="help/img/select_group_have.png" alt="Group by having" class="leftFloatIMG" style='margin-top:10px'>
<p class="text">The 'GROUP BY' with 'HAVING' input is used if you use a 
    <span class="groupLinks pointer" onclick="fetchthelink('Help/groupfunction/avg.html', '#63a65a');">groupfunction</span> and want to requiere the order. 
    If you use 'GROUP BY' be sure to use the same tables in the group, which you used in the select.
    <br><span style="font-weight: bold;">Notice</span> that only the tables should be used which are not in a groupfunction.<br>
    In the 'HAVING' input you need to use a 
    <span class="groupLinks pointer" onclick="fetchthelink('Help/compare_operator.html', '#5aa68c');"> compare operator</span>.<br> 
    You can use this clause with the 'LIMIT' clause</p>
<h3 id="ob"> ORDER BY </h3>
<img src="help/img/select_order.png" alt="order by" class="rightFloatIMG" style='margin-top:10px'>
<p class="text">The 'ORDER BY' input is used if you want to order your result after a specific order. 
    If you use 'ORDER BY' be sure to use one of the tables in the 'ORDER BY', which is also used in the select. 
    You also can use the <span class="groupLinks pointer" onclick="fetchthelink('Help/fieldname_get.html', '#63a65a');">alias variable</span> here. You can sort your results ascendant or descandent.<br> You can use this clause with the 'LIMIT' clause</p>
<h3 id="lim"> LIMIT </h3>
<img src="help/img/select_limit.png" alt="limit" class="leftFloatIMG" style='margin-top:10px'>
<p class="text">The 'Limit' input is used if you want to limit your result after. 
    It is used with a number variable and you can use it with the other clauses.</p>
<h2 id ="type" style="margin-top: 25px;">The types</h2>
<img src="help/img/select_type_list.png" alt="Type list" class="img" style="margin-top: 10px;">
<p class="text"> This colour gradient, apple green to cyan, symbolises a list of columns of the database</p>
<img src="help/img/select_type_int.png" alt="Type numeric" class="img" >
<p class="text"> This colour gradient, violet to cyan,  symbolises the numeric values of the database</p>
<img src="help/img/select_type_text.png" alt="Type text" class="img">
<p class="text"> This colour gradient, brown to cyan, symbolises the textual values of the database</p>
<img src="help/img/select_type_date.png" alt="Type date" class="img">
<p class="text"> This colour gradient, tapestry to cyan, symbolises the date values of the database</p>
<img src="help/img/select_type_bool.png" alt="Type bool" class="img">
<p class="text"> This colour, cyan, symbolises the boolean values of the database</p>
<div id="aliasback"></div>